Flexi Integration

The netFORUM integration for Flexi accounting is a simple export of G/L information from the netFORUM batch and be imported into Flexi accounting by the client.

Setting Up Flexi

Integration Classification

Class A - Baseline

Client Tasks/Requirements

  1. Client needs to have Flexi accounting software installed
  2. Client needs to have knowledge about how to import G/L files into Flexi

Abila Tasks

This integration requires System Option setup.

Baseline File Layout

Sample File Layout for summary system option

Example: H,X,,BATCHNAME,20090617,1340.00,1340.00,1,3,4,0,USD,X,0,,,,ASTC,0,0,0,0,,0,,,,,, D,1010000000,BATCHNAME,1340.00,,,,,,,,,, D,3200000000,BATCHNAME,-120.00,,,,,,,,,, D,4300000000,BATCHNAME,-1190.00,,,,,,,,,, D,4400000000,BATCHNAME,-30.00,,,,,,,,,,

Sample File Layout for detail system option

Example: H,X,,BATCHNAME,20090617,5360.00,0.00,20,0,20,0,USD,X,0,,,,ASTC,0,0,0,0,,0,,,,,, D,2000000000,BATCHNAME,495.00,,,,,,,,,, D,2000000000,BATCHNAME,15.00,,,,,,,,,, D,1010000000,BATCHNAME,15.00,,,,,,,,,, D,1010000000,BATCHNAME,15.00,,,,,,,,,, D,1010000000,BATCHNAME,120.00,,,,,,,,,, D,1010000000,BATCHNAME,495.00,,,,,,,,,, D,2000000000,BATCHNAME,15.00,,,,,,,,,, D,2000000000,BATCHNAME,120.00,,,,,,,,,, D,1010000000,BATCHNAME,695.00,,,,,,,,,, D,2000000000,BATCHNAME,695.00,,,,,,,,,, D,2000000000,BATCHNAME,15.00,,,,,,,,,, D,2000000000,BATCHNAME,120.00,,,,,,,,,, D,4400000000,BATCHNAME,15.00,,,,,,,,,, D,4400000000,BATCHNAME,15.00,,,,,,,,,, D,4300000000,BATCHNAME,495.00,,,,,,,,,, D,4300000000,BATCHNAME,695.00,,,,,,,,,, D,3200000000,BATCHNAME,120.00,,,,,,,,,, D,2000000000,BATCHNAME,15.00,,,,,,,,,, D,2000000000,BATCHNAME,495.00,,,,,,,,,, D,2000000000,BATCHNAME,695.00,,,,,,,,,,

When the BatchExportMethod is set to detail the detail export file will contain a row for each ledger record created from the batch close process. When the BatchExportMethod is set to summary only one row will appear in the detail export file for each unique G/L Account. Generally Abila recommends exporting in summary rather than detail.

Usage and Instructions

Once the file is generated after the post batch process from the netFORUM batch profile, staff should go to the Flexi and import the file.

Additional Services

If the file layout shown above does not meet client's requirement and client requires Abila to make such change, additional fee will be needed to perform such change. The additional fee will be based on the complexity and the content of the file layout.

Tip: This process requires that you modify the BatchExportMethod system option.